<cfoutput>


<cfset today = now()>
<cfset mytime = timeformat(now(), "hh:mm:ss tt")>
<cfset reportdate = dateformat(today, "mm/dd/yyyy")>


<CFQUERY DATASOURCE="#dsn#">
INSERT INTO tblcash (Amount, TransDate, ReportDate, Username, Terminal, TransTime, EODBalance)
VALUES (
#Amount#,
<cfqueryparam cfsqltype="cf_sql_timestamp" value="#today#">,
'#reportdate#',
'#session.username#',
'#session.terminal#',
'#mytime#',
0
 
)
</CFQUERY>


<cflocation addtoken="yes" url="form_cash.cfm?message=Terminal ID: #session.terminal# <BR><BR>Status: Open <br><br>Starting Balance: $#form.amount#">



</cfoutput>